package com.example.demo.repository;

import com.example.demo.model.Klass;
import com.example.demo.model.Student;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface KlassRepository extends JpaRepository<Klass, String> {
//    //List<Student> findByNameAndAge(String name,Integer age);
//    List<Student> findByName(String name);
//    List<Student> findByNameAndAge(String name,Integer age);
//    List<Student> findByNameOrAge(String name,Integer age);
//    @Query(nativeQuery = true,value = "select * from student where name = ?1")
//    List<String > findByNativeQuery(String name);

//    List<Klass> findAll();

    List<Klass> findByNameAndMajor(String name, String major);

    List<Klass> findByName(String name);

    @Query(nativeQuery = true,value = "select * from klass where name = ?1")
    List<Klass> findByNativeQuery(String name);

}